It's fair to say that, for most middle-aged British women, the menopause is not something that evokes excitement.